package cn.gson.fengboot.model.mapper;

import cn.gson.fengboot.model.pojos.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface TfyclientMapper {
    //客户、模糊查询
    public List<TfyclientForm> findAllClient(@Param("search") String search, @Param("search1") String search1);

    //根据员工id查询客户、模糊查询
    public List<TfyclientForm> findAllygClient(@Param("search") String search, @Param("empId") Integer empId);

    //已关注客户、模糊查询
    public List<TfyclientForm> findAllClientgz(@Param("search") String search);

    //已失效客户、模糊查询
    public List<TfyclientForm> findAllClientzt(@Param("search") String search);

    //客户id查询
    public TfyclientForm findIdClient(@Param("clientId") Integer clientId);

    //今日需联系客户、时间查询
    public List<TfyclientForm> findClientDate();

    //分配给我的客户查询
    public List<TfyclientForm> findClient(String search);

    //客户id查询跟进记录
    public List<Dtail> selectAllTails(@Param("clientId") Integer clientId);

    //客户id查询商机信息
    public List<Dbusiness> findclientsj(@Param("clientId") Integer clientId);

    //客户id or id查询商机信息
    public List<Dbusiness> findclientsjtwo(@Param("clientId") Integer clientId, @Param("clientId2") Integer clientId2);

    //查询员工和对应部门
    public List<QempFrom> findemp(@Param("search") String search);

    //根据员工id查询员工信息
    public QempFrom cxidemp(@Param("empId") Integer empId);

    //<!--根据导入负责人名称查询员工名称-->
    public QempFrom cxempname(@Param("empName") String empName);

    //查询客户名称是否相同
    public Integer cxclientname(@Param("clientName") String clientName);

    //客户地图报表
    public List<TfyclientForm> findditu();

    //客户饼状图报表 客户行业
    public List<TfyclientForm> findbingz();

    //客户饼状图报表 客户来源
    public List<TfyclientForm> findbingzer();

    //客户饼状图报表 客户级别
    public List<TfyclientForm> findbingzsan();

    //客户饼状图报表 客户类型
    public List<TfyclientForm> findbingzsi();

    //柱状图
    public List<TfyclientForm> findzhuz();

    //客户全部视图
    public List<Tfyselectvo> allselect(@Param("clientId") Integer clientId);

}
